﻿CREATE PROCEDURE ReportUnapprovedEntries
AS
BEGIN
	select distinct p.Name, u.FullName, e.EntryDate, e.BillableHours
	from EntryLog e inner join
		 Projects p on e.ProjectID = p.ProjectID inner join
		 Users u on e.UserID = u.UserID
	where e.BillingStateID = 1 and u.IsActive = 1
	order by p.Name, u.FullName, e.EntryDate
END